Setting advanced connection properties
In the Advanced tab, you can set the parameters described in the table below.
| Option | Description |
|---|---|
|
Relevant for all task types. The maximum size a CSV file can reach before it is loaded/applied to the target. If you encounter performance issues, try adjusting this parameter. |
|
|
The name of the default ODBC driver you are using to connect to Snowflake. The default value is SnowflakeDSIIDriver. |
|
|
Additional ODBC connection properties |
Type any additional ODBC connection properties if required. |
| Option | Description |
|---|---|
|
Use proxy server |
Select this option to access Amazon S3 via a proxy server. |
|
Host name |
The host name of the proxy server. |
|
Port |
The port via which to access the proxy server. |
|
User name |
The user name for accessing the proxy server. |
|
Password |
The password for accessing the proxy server. |
|
Scheme |
Select which protocol to use to access the server (HTTP or HTTPS). In order to use HTTPS, you must first install the CA certificate that signed the proxy’s certificate on the Replicate Server machine. Do this as follows:
The HTTPS proxy scheme is supported for AWS S3 staging only. It is not supported for Snowflake staging or Snowflake Access (ODBC). See also: Setting general connection parameters. |
| Option | Description |
|---|---|
| Number of files to load per batch |
Relevant for Full Load tasks only. The number of files to load in a single batch. If you encounter performance issues, try adjusting this parameter. |
| Batch load timeout (seconds) | If you encounter frequent timeouts when loading the files, try increasing this value. |
Internal parameters
Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.
To add internal Qlik Replicate parameters:
-
Click the Internal Parameters link.
The Internal Parameters dialog box opens.
- In the edit box, type the name of the parameter you need to add and then click it.
- The parameter is added to the table below the search box with its default value.
- Change the default value as required.
- To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.
More options
These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.
To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.
Settings summary
You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.